Invoice Formats

This chapter contains the following topics:

Introduction to Invoice Formats

Printing a Location Grid

Printing a Layout Worksheet

Entering Invoice Formats

General Appearance

Header Area

Line Item and Payments Area

Totals Area

Verifying the Format

Printing a Sample Invoice

Printing Format Specifications

Copying Invoice Formats

Deleting Invoice Formats

 

Introduction to Invoice Formats

The Invoice Formats selection enables you to tailor the Passport Business Solutions Accounts Receivable module to work with your invoice forms.

You do not have to change to an unfamiliar or undesirable invoice form in order to use this module, but can configure A/R to print on your current invoice form or nearly any other invoice form you wish.

If you do not use an invoice form, but simply use your blank letterhead, you can tailor A/R to use this also. In Windows or Thin client, you can also merge a graphical file with the file data that contains the lines, logo, different colors, header names and so on.

You can even arrange it so that you can print the same invoice in two or more different formats, to be used for different purposes for instance, one format to send to the customer and another format to use internally.

An invoice format is sometimes referred to as a layout. It is also sometimes called a specification.

The following lists some of the definitions that are used in the invoice tailoring process.

Field location grid

The Field # location grid is a set of vertical and horizontal lines of numbers which you can print on your preprinted invoice form or graphic image file to aid in positioning information so that it matches up horizontally and vertically with the titles and lines already on the form.

Invoice layout worksheet

The invoice layout worksheet is a set of numbered vertical and horizontal lines which you can print on a blank sheet of paper to create your invoice from scratch.

 

 

 

 

 

 

 

 

 

Top Margin

 

 

1

2

3

4

5

6

7

8

9

0

 

 

1

 

 

 

 

 

 

 

 

 

 

 

Left

2

 

 

 

 

 

 

 

 

 

 

 

Margin

3

 

 

 

A

 

 

 

The location of the letter A is at row 3, column 4

 

4

 

 

 

 

 

 

 

Line or row

Line or row refers to the cells arranged horizontally in a table.

Column

Column refers to the cells arranged vertically in a table.

Location

Location refers to the row and column of the printed information on the page.

Format design kit

Format design kit refers to the appendix Invoice Format Design Kit, which provides the step-by-step procedure to set up a new invoice format.

Basic Invoice Format

The invoice format consists of three areas:

1

Header

2

Line item 1

Line item 2

Line item 3

etc.

Payment 1

Payment 2

etc.

3

Totals

Header

The Header area is the first part of the invoice and includes information pertaining to the overall invoice: i.e., customer’s name and address, invoice date, invoice number, your company’s name and address, etc.

Line item and Payment

The Line item area is the middle part of the invoice and includes information on all the line items (goods and services) you are billing the customer for: descriptions, quantities, prices, etc. It can also include notes giving additional information about the goods and services.

The line item area also shares the payments if you are using multi-payments. You may assign payment fields to the invoice format. They print are AFTER the last line, service item or note. If there is more than one payment, then the print one after another. In order to print payment information you must be licensed for multi-payments. See the PBS Multi-payment Setup appendix for more information.

Totals

The Totals area is the last part of the invoice and includes the total amount of the invoice, over-all discounts, taxes, miscellaneous charges, etc.

 

       Note 

Each of the available fields can be printed in as many as four different locations subject the following overall limits for the different invoice areas.

Maximum Number of Locations

In the header area, the maximum number of locations in which you can print fields or text is 100 (including the copies of any of the available header fields printed in up to 4 different locations).

In the line item area, the maximum number of locations in which you can print fields or text is 80.

In the totals area, the maximum number is 80.

Creating an Invoice

The A/R module comes with a number of predefined invoice formats. If one of these is close to the one you want, just make a copy of it and then make changes to the copy. Refer to the Invoice Format Design Kit appendix for guides to modifying invoice formats and for designing invoice formats from scratch.

Passport recommends that you first become familiar with printing invoices in the predefined formats furnished with this module before designing your own.

The remaining parts of this chapter describe the A/R functions you run in accordance with the checklists in the Invoice Format Design Kit appendix.

If you are ready to add a format now, refer to the appropriate checklist in the Invoice Format Design Kit. The checklist will refer you to the parts of this chapter you need to perform the steps for adding formats.

Printing a Location Grid

The field location grid is a tool you can use to plan your invoice form when you are using a preprinted invoice form or graphic image file. Print this grid on your invoice form, to see the exact rows and columns of every piece of invoice information on the pre-printed form or file. You will then be able to specify the exact row and column for each piece of information when you create your invoice format.

This grid may also be useful to plan the layout of forms that you design, so you can avoid overlapping fields, a confusing layout, and when using Windows printer or a PDF printer and when merging with a graphical form file.

Select

Location grid from the Invoice formats menu.

The following screen appears:

Enter the information as follows:

1. # of rows on the form (top to bottom)

Enter the number of rows to appear on the grid.

The number you enter corresponds to the number of rows on your invoice form.

<F2>

For 66 rows (8¾ X11 paper with no allowance for top or bottom margins)

<F5>

For 63 rows (this is the maximum recommended amount if you are using Windows printer.)

       Note 

Most laser printers are unable to print on the first 1/6th inch at the top of a page and on the last 1/6th inch at the bottom of a page. Because of this physical limitation, the first row of a location grid will not be printed on a laser printer. The last row will not be printed when it falls within the last 1/6th of an inch of the page. For example, if you enter 66 for # of rows on the form and print on letter size
(8 1/2 X 11) paper, row 1 and row 66 will not print.

When selecting Windows printer, the print limitations is determined by the printer driver. These limitations can differ per version of the driver.

2. # of print columns (left to right)

Format

99

Example

Press <F2>

Enter the number of columns to appear across the page on the grid.

Options 

The maximum number of columns you can specify is 132.

<F2>

For 80 columns (8¾ X11 paper with º inch allowance for left and right margins)

Format

99

Example

Press <F2>

3. Graphic image file name ?

Enter the name of the file that will merge with the invoice data. This JPEG or Bitmap file must be present in the top-level PBS directory - IMAGES.

See the Form File Use and Design section in the More on PBS Printing chapter In the PBS Administration documentation to learn more about modifying the PBS graphical file examples or creating your own from scratch.

You may use the option:

<F2>

To not use a graphical image file and print on letterhead

The file must be present in the IMAGES directory and must be spelled exactly as the file name with the proper extension included. If running in Linux or UNIX Thin client, the file name must be entered with the same (UPPER or lower) case and do NOT use a period as part of the file name.

Format

12 characters, but the extension must be either .jpg or .bmp.

Example

Enter IV65F1.JPG

If you want a graphical image file to print on the page, then you must select Windows printer or a Company information PDF printer when you print the grid. In regards to Company information printers, only PDF printers will merge the image file with the data.

When using Windows printer merging with a graphical image is only available when running on Windows or Thin client. Merging with a graphical image when using a Company information PDF printer will work on all operating systems that PBS supports.

Field number to change ?

Make any needed changes, then press <Enter>. The following message is displayed:

Make sure your form is now in the printer, and that the printer will begin printing at the first print position of the very first line of the form.

Type "DONE" when ready.

The printer should always be ready to print in location 1,1 (that is, row 1, column 1).

Type DONE and the location grid will print. A sample location grid appears at the end of this chapter.

After the grid is printed, you are asked whether you want to print it again. If you answer Y, the grid is printed a second time. If you answer N, the following message is displayed:

If you have pre-printed forms mounted on the printer, replace these now with regular paper.

Type “DONE" when ready.

Type DONE and press <Enter>.

Printing a Layout Worksheet

The layout worksheet is a tool to help you lay out your invoice on blank paper, continuous-form company letterhead or when using Windows printer and merging with a form file. Whereas the location grid has rows and columns of numbers, the layout worksheet has rows of dotted lines on which you can fill in invoice information in the way you want it printed.

You can also print the layout worksheet on a preprinted form if you wish.

Select

Layout worksheet from the Invoice formats menu.

The following screen appears:

Enter the information as follows:

1. # of rows on the form (top to bottom)

Enter the number of rows to appear in the worksheet.

Options 

The number you enter corresponds to the number of rows on your invoice form. If you are using Windows printer, you may have to enter 63, 62 or even less. It depends on what is allowed by your printer model.

<F2>

For 66 rows (8 X 11 paper with no allowance for top or bottom margins)

 

       Note 

There are certain limitations to printers.

When printing using a Company information laser printer, it is unable to print on the first 1/6th inch at the top of a page and on the last 1/6th inch at the bottom of a page. Because of this physical limitation, the first row of a location worksheet will not be printed on a laser printer. The last row will not be printed when it falls within the last 1/6th of an inch of the page. For example, if you enter 66 for # of rows on the form and print on letter-size 8¾ X11 paper, row 1 and row 66 will not print.

When printing using Windows printer, the limitation may be different per printer model based on margins defined in the printer driver.

Generally you have less printable area using Windows printer than when using a printer defined in Company information and your format design should reflect this. For example, a Company information printer setup may allow 66 lines but a Windows printer may only allow 62 lines. Refer to your printers documentation to determine available printable area on the page.

Format

99

Example

Press <F2>

2. # of print columns (left to right)

Enter the number of columns to appear across the page on the worksheet.

Options 

The maximum number of columns you can specify is 132. For Windows printer you may have to enter a number less that 80.

<F2>

For 80 columns (8¾ X11 paper with º inch allowance for left and right margins)

Format

99

Example

Press <F2>

3. Graphic image file name ?

This field is only available in Windows and Thin client.

Enter the name of the file that will merge with the invoice worksheet. This JPEG or Bitmap file must be present in the top-level PBS directory - Images.

You may use the option:

<F2>

To not use a graphical image file and print on letterhead or plain paper without an image file

The file name must be spelled exactly as the file name with the proper extension included.

Format

12 characters, but the extension must be either .jpg or .bmp.

Example

Enter IV65F1.JPG

If you want a graphical image file to print on the page, then you must select Windows printer when you print the worksheet. The printers defined in company information will not merge the image file with the data.

Merging with a graphical image is only available when using Windows or Thin client.

Field number to change ?

Make any needed changes, then press <Enter>. The following message is displayed:

If you wish to print the worksheet on a pre-printed form, mount your form on the printer now.

Type DONE when ready

The printer should always be ready to print in location 1,1 (row 1, column 1).

Type DONE and the worksheet will print. A sample layout worksheet appears at the end of this chapter.

After the layout worksheet has printed, you are asked whether you want to print it again. If you answer Y, another worksheet will be printed. If you answer N, the following message is displayed:

If you have pre-printed forms mounted on the printer, replace these now with regular paper.

Type “DONE” when ready.

Type DONE and press <Enter>.

Entering Invoice Formats

Select

General appearance from the Invoice formats menu.

A screen appears for you to either assign a number and description to a new invoice format you want to add or to retrieve an existing format. Enter the following information:

1. Format #

Options 

Enter a format number, or use one of the options:

<F1>

For the next format on file

<SF1>

For the previous format on file

Format

99

Example

Type 11

2. Description

Enter a description of the format. This field is required.

Format

25 characters

Example

Type Example format

Field number to change ?

Options 

Make any needed changes or press <Enter> to continue.

The checklists in the Invoice Format Design Kit describe the exact steps to add a new format or modify an existing format. Briefly, the sequence from this point on is:

Use General appearance to specify the general, over-all appearance of the format: how long, how wide, specifying an image file, etc.
Use Header area to select which fields or texts to print in the header area of the invoice, where they should print and how they should look. Then use Line item area and Totals area similarly.
Use Verify to check the format for errors. Make any necessary corrections.
Use the Sample invoice to confirm that the form is what you want.

General Appearance

Select

General appearance from the Invoice format menu.

An entry screen will be displayed prompting you for the invoice format number that you want to work with.

Options 

Enter a format number, or use one of the options:

<F1>

For the next format on file

<SF1>

For the previous format on file

Format

99

Example

Type 11

The following screen displays for General Appearance:

Enter the information as follows:

1. # of rows on the form (top to bottom)

Enter the number of rows on the invoice form or use the option:

<F2>

For 66 rows (six rows per inch on standard 8/11 inch paper)

 

       Note 

If you wish to use a form with more than 66 rows on a laser printer, you must use Company information to set up an Other laser printer with the proper job control codes. To print on legal size paper, you must use the appropriate job control codes to set the text length to 84 rows. For an explanation of the hexadecimal codes used for job control, refer to the Special Forms and Laser Printers section of the Company information chapter in the PBS Administration documentation.

Format

99

Example

Press <F2>

2. # of print columns (left to right)

Options 

Enter the number of columns on the invoice form (up to 132) or use the option:

<F2>

For 80 columns (ten characters per inch on standard
8 X 11 inch paper)

Format

999, not to exceed 132

Example

Press <F2>

3. Print header data on first page only ?

Answer Y to print the header information, such as customer and customer ship-to addresses, on only the first page of the invoice. Answer N to print it at the top of every page of the invoice.

Format

One letter, either Y or N. The default is Y.

Example

Press <Enter>

4. First row # for line item printing

Enter the row number on which you want the first line item to start printing (from 3 to [maximum rows on form minus 4]). As an illustration, if you had specified in Field #1 above that the number of rows on the form was 66, you could enter a number from 3 to 62 (66 minus 4).

Be sure to leave room for the header area, and also for any blank rows to separate the header area from the line items.

Format

99

Example

Type 28

5. Last row # for line item printing

Enter the row number of the last row in the line item area. Line item information will never print after this row number. This number must be larger than the row on which you want the first line item to start printing (entered in 4 above), but smaller than the maximum rows on the form minus 3. Continuing the illustration above, if you entered 28 for the first row number for line item printing, you could enter a number from 4 to 63 (66 minus 3).

Be sure to leave room for the totals area, and also for any blank rows to separate the totals area from the line items.

Format

99

Example

Type 56

6. Maximum # of rows per line item

Enter the maximum number of rows to print per line item, from 1 to 12. This number cannot be larger than the difference between the numbers entered in Fields #4 and 5 above, plus 1.

For instance, if you were designing a very short form and had specified above that the first row for line item printing is 9 and the last row is 15, the rows per line item could not be larger than 7 (15 - 9 + 1).

       Note 

The A/R module allows you to have "services" line items and "notes" line items, each with up to 10 lines of description. Specify enough rows to print the longest note or description of services you want to show on the invoice. This is the maximum number of rows per line item. If a line item consists of less than this, only the lesser number of rows will be printed

Format

99

Example

Type 5

7. Skip a row between line items ?

If the number of rows per line item is 1, either answer Y to skip a row between line items (double-space them) or N to print them single-spaced.

Format

One letter, either Y or N

Example

Type N

8. Split line items between pages ?

If the number of rows per line item is 2 or more, answer Y to allow line items to be split between pages. Or answer N to keep all information for one line item on the same page.

If the number of rows per line item is 1, (Not applicable) displays.

Format

One letter, either Y or N

Example

Type N

       Note 

If you select N to split line items between pages, the number of unused lines at the bottom of every lines section is equal to the number entered in field 6 Maximum # of rows per line item. If that number is 3 or more you may get better results by allowing to split items between pages.

9. First row # for totals section

Options 

Enter the row number of the first row of the totals section, or use the option:

<F2>

To leave two blank rows after the last line of the last line item printed and then immediately start printing the totals

These are called floating totals, since the totals area floats two rows below the last line of the last line item instead of being printed at a fixed row number on the form.

Format

99

Example

Press <F2>

10. Order of printing of line items

Enter S to print the line items in sequence number order, or type L to print them in order by line type (goods, services, and notes).

Format

One letter, either S or L. The default is S.

Example

Press <Enter>

11. Use pre-printed forms ?

If this invoice format is to be used with preprinted forms, answer Y; otherwise, answer N. If you answer Y, you will be prompted to mount preprinted forms on the printer during the Print invoices selection.

Format

One letter, either Y or N

Example

Type N

Print using graphic image ?

Answer Y to use a graphic image form file to merge with the data or N to print without an image file.

Format

One letter, either Y or N

Example

Type N

If you answer Y, then you will be prompted to enter the name of the file.

If you are using a graphical image file, then you must select Windows printer or a -PDF- Company information printer when you print invoices.

File name:

You must make an entry in this field if you select Y to Print using graphic image ?.

Enter the name of the file that will merge with the invoice data. This JPEG or Bitmap file must be present in the top-level PBS directory - IMAGES.

The file must be present in the IMAGES directory and must be spelled exactly as the file name with the proper extension.

Format

12 characters, but the extension must be either .jpg or .bmp.

Example

Enter INV651.JPG

If you are using a graphical image form file, then you must select Windows printer or a PDF printer when you print invoices. Other than a PDF printer, the printers defined in company information will not merge the image file with the data.

Field number to change ?

Make any desired changes. If you change Field #4 or 5, you will automatically go to Fields #6, 7, and 8 for you to either confirm or change your entries. The entry for Field #9 must also be confirmed unless Floating totals was selected.

Press <Enter> to continue.

If you are printing line items in sequence number order (as indicated by Field #10), your entries for General appearance are complete.

If you are printing line items in order by line type, the following screen appears:

Enter the information as follows:

12. First type of line item to print

Select the type of line item you want to print first on the invoice: G (Goods), S (Services), or N (Notes).

Format

One letter from the list above

Example

(This screen does not appear in this example because you chose to print invoices by sequence number)

13. Second type of line item to print

Select the type of line item you want to print next on the invoice (either of the two remaining line types above). Whatever line type is left over automatically becomes the third type of line item to print.

Format

One letter from the list above

Example

(Does not appear in this example)

14. Print line type sub-totals ?

Each line item has a line item net amount which is the amount you are billing the customer for that line item. Answer Y to print a sub-total of the net amounts for all Goods after the Goods line items and for all Services after the Services line items.

Format

One letter, either Y or N

Example

(Does not appear in this example)

15. Description of goods sub-totals

If you answered N in the 14. Print line type sub-totals ? field, this field displays as (Not applicable) and may not be entered.

Options 

Otherwise, enter the description that you want to print on the same row as the Goods Subtotal Amount. You may use the option:

<F1>

For Goods

Format

12 characters

Example

(Does not appear in this example)

16. Description of services sub-totals

If you answered N in Field #14, this field displays as (Not applicable) and may not be entered.

Options 

Otherwise, enter the description that you want to print on the same row as the Services Subtotal Amount. You may use the option:

<F1>

For Services

Format

12 characters

Example

(Does not appear in this example)

Field number to change ?

Make any desired changes, then press <Enter> to complete entry of General appearance parameters for this invoice format.

Header Area

When entering a new invoice format, General appearance must be entered before this selection may be entered.

Here you choose the header fields you want to print on your invoices and/or specify text you want printed in the header area. Field contents are printed, not their titles. For example, selecting the field Customer number containing AB1079 means that AB1079 is printed, not Customer number. To print field names (captions), specify them as text to be printed.

If you want to print a title on the invoice, you must specify a text to print. This is explained in detail below.

Select

Header area from the Invoice formats.

An entry screen will be displayed prompting you for the invoice format number that you want to work with.

Options 

Enter a format number, or use one of the options:

<F1>

For the next format on file

<SF1>

For the previous format on file

Format

99

Example

Type 11

A list appears showing the first 10 fields available to you for printing in the header area of the invoice. If you have previously selected any of these fields to print, an asterisk will appear next to the field number

You can press <F1> to see a diagram of the invoice you are adding or editing. This diagram will display all the fields and text you have selected to appear on the invoice in its proper format position.

Use the PgDn and PgUp keys to scroll through the fields that are available for inclusion in the invoice header area.

Use the <F2> key to shift the format to the left and to the right.

Which particular Invoice Fields are available to you is determined by decisions made in the Control information selection of A/R (and sometimes that of other modules); also in the System Manager Company information selection. For example, if your company does not use cost centers or ship-vias, those fields do not appear.

Invoice fields may be selected and placed on the format in any order.

1. Field #

Options 

Enter the number of the invoice field to be placed on the invoice format. You may select an invoice field even though it has already been selected (that is, the same field may appear in more than one place on the invoice). You may also use one of the options:

<PgUp>
<PgDn>

To move the display up or down one page. You cannot move up if you are already on the first page, nor down if on the last one.

<F1>

To view a schematic picture of the invoice, showing all fields defined thus far.

Format

99 The number entered must be one of those currently showing on the display. You may also leave this field blank to enter text.

Example

Type 1 to select Invoice number.

The following screen appears:

The fields that appear after row and column depend on what kind of information is in the field. There are three different kinds of information:

Alphanumeric (letters, digits, and special symbols)
Date
Numeric (digits, decimal point, minus sign, commas, and parentheses)

Numeric Fields

Invoice number is a numeric field and the screen will appear as shown above.

The choices for a numeric field depend on the characteristics of that particular field. For instance, its maximum length, whether negative numbers are allowed, does it have any decimal places, etc.

The Invoice number field cannot be negative. It cannot contain commas or decimal places, so the screen appears as above. An example of a numeric field that can be negative, and can have decimal places and commas, is shown in an example in the Line item area section later in this chapter.

For the Invoice number field, enter the information as follows:

2. Row

Specify in which row to print this field.

Format

99

Example

Type 6

3. Column

Specify the starting column in which to print this field.

Format

999

Example

Type 61

4. Number of integers

Enter the number of digits you want printed to the left of the decimal point up to the maximum shown. (In this example, the invoice does not have decimal places, so all digits are considered to be to the left of the decimal point.)

Format

99 The maximum available for this field displays as the default.

Example

Press <Enter> for the maximum of 6

5. Print lead zeros ?

Answer Y to print leading zeroes, or N to suppress leading zeroes. For instance, if the invoice number is 236 and the number of integers is 6, then if you answer Y, the invoice number will print as 000236. If you answer N, it will print as 236.

Format

One letter, either Y or N

Example

Type Y

Field number to change ?

Options 

Make any desired changes, or use the option:

<F1>

To view a schematic picture of the invoice

When you press <Enter>, the screen clears for you to enter another field number to select.

Modifying Fields

This section describes how to make changes to a field you have already specified. You can change the location, delete the entry altogether, or print the field at additional locations in the header area.

When positioned to enter another field or when first displaying an existing format, enter the field number. If the field has already been selected for use on this format, a "Field usage" window appears, showing the row[s] and column[s] where it is currently specified to print.

1. Field #

Format

99

Example

Type 1 to reselect the Invoice Number field

The screen now looks like this:

Notice the appearance of the Field usage box, which indicates the places where this field is already used (up to four, and in this case one).

2. Row
3. Column

Enter the same row and column as before:

Format

99 for row

999 for column

Example

Type 6 for row

Type 61 for column

Field number to change ?

Options 

Since this is an existing location on the invoice format, Screen Fields #4 and 5 display automatically and the cursor is positioned here. Your options now are:

<F1>

To view a schematic picture of the invoice

<F3>

To delete this field from this location of the invoice (without affecting any other location where it may occur)

Changing a Field Without Changing Its Location

If you want to change how a field appears (length, etc.) in a location you have already specified, select the field number as above.

Enter the row and column of the location you want to change. Make any desired changes.

Changing the Location of a Field

If you want to change where a field prints without otherwise changing its appearance, select the field number as above. Enter the row and column of the location you want to change. Make any changes to its row and/or location from Field number to change ?. When no more changes are required, press <Enter>.

Deleting a Field

If you want to delete a field in a location you have already specified, select the field number as above. Enter the row and column of the location you want to delete. When prompted, press <F3> to delete the field from this location.

If you specified earlier that this field is to be printed in more than one location, the field will be deleted from the current location selected, by not from the other locations.

Printing a Field in More than One Location

You can print any field in up to four different locations in the header area.

Enter the new location (row and column), then specify how to print in the field in the new location.

Date Fields

Date fields are specified as follows:

1. Field #

Format

99

Example

Type 2 to select Invoice date

The screen displays as follows:

2. Row and
3. Column

Enter the row and column in the same way as for a numeric field.

Format

99 for row

999 for column

Example

Type 6 for row

Type 51 for column

4. Date format to use

Enter one of these choices for how the date is to appear:

1

=

MM/DD/YY

2

=

MM/DD

3

=

DD-MMM-YY

4

=

DD-MMM

5

=

Month Fully Spelled

When you make the choice, the Will look like field on the right side of the screen shows how the date will look. The length of the field displays so you will know how much room this field will occupy on the invoice.

Format

One number from the list above

Example

Type 1

Field number to change ?

Press <Enter> to terminate the date example.

Alphanumeric Fields

All alphanumeric fields allow the same set of choices, as shown below. The maximum size of the field depends on the particular field you have chosen. You specified the maximum sizes of some fields in Control information; the maximum sizes of other fields are preset by the software.

1. Field #

Format

99

Example

Press <PgDn> for the second page of the available field number display.

Type 17 to select Customer name as the next invoice field to be added to the format.

The following screen appears:

2. Row
3. Column

Enter the row and column in the same way as for a numeric field.

Format

99 for row

999 for column

Example

Type 15 for row

Type 8 for column

4. Length to print (maximum = nn)

Enter the number of characters you want to print in this field.

The maximum number shown is the size of that field as it is stored in the software, but because of the way you have defined the format the entire length may not be available to you. You may need to experiment a bit with the layout if your previous choices impose limits which you do not want.

Format

99 The maximum for this invoice field displays as the default.

Example

Press <Enter> for 25

5. Justify

Justify means to adjust the spacing of characters within the space allowed.

Enter one of the following options:

L

To left justify

R

To right justify

N

No justification. Information prints exactly as entered.

For instance, you might have already centered your company’s name and address when you entered them in the Company information function. To print them this way, type N.

Format

One letter from the list above. The default is L.

Example

Press <Enter>

Field number to change ?

Press <F1> to view the invoice.

Inserting Text in the Header Area

You would usually print text next to fields containing information. In particular, if you do not have a preprinted invoice form but print invoices on blank paper, you would specify text (captions) to print alongside or above the actual invoice information.

1. Field #

Format

99

Example

Press <Enter>. The word Text will display.

2. Row
3. Column

Enter the row and column where you want this text to begin.

Format

99 for row

999 for column

Example

Type 4 for row

Type 51 for column

4. Text

Enter the exact text you want to appear in that row and column. A ruler beneath the field to be entered lets you see exactly in which column each character is entered:

Text length is restricted to forty characters (or less if the right border of the invoice is encountered, as it is in this example). To print longer texts, enter each group of forty characters as a separate text.

Format

40 characters

Example

Type Invoice

5. Suppress ?

Answer Y if you want the text to be suppressed (not to print) when some field (to be specified next) is zero or blank. For instance, if you are interfaced to J/C you might not want the caption Job: to print when the job number field is blank (that is, when the invoice is not for a job).

Format

One letter, either Y or N. The default is N.

Example

Press <Enter>

Field #

If you answered Y to Screen Field #5, the available header fields display. Enter the number of the field which, when it contains zero or blank, will cause the text not to print.

If this field is not already selected to print on the invoice, you get a warning message, but your choice is still accepted. Make a note to select the field later. The field you select here must also be selected to print on the invoice.

Viewing the Format

Whenever you are at field 1 of the header field selection screen, or are at "Field number to change ?" on a text screen, you can press <F1> to see what the invoice looks like.

The following screen appears:

X’s will appear to represent the alphanumeric fields that you have selected for the invoice, and will occupy the length and locations you have selected. 9’s will appear for your numeric fields. ?’s will appear where any of the fields overlap, in which case you need to change the position of a field.

If yours is a color monitor, each portion of the invoice (header, line items, or totals) will be a different color.

Options 

To view a different part of your invoice, enter the number of the last line you want to view. You may also use one of the following options:

<Up>
<Down>

To scroll the invoice up and down by one row at a time.

<PgUp>
<PgDn>

To shift your view of the invoice up and down a screen at a time.

<F1>

To toggle between displaying service-only fields and goods-only fields. This option appears only if at least one such field has been selected.

<F2>

To toggle between viewing the leftmost 78 characters or the rightmost 78 characters of the invoice.

<Esc>

To leave this screen and return to the format header screen.

Format

99

Example

Press <Esc> to return to Field number to change ?.

Press <Enter> to return to Screen Field #1.

Options 

Make any needed changes. Your options are:

<F1>

To view a schematic picture of the invoice

<F3>

(For an existing text only) To delete this text

If you press <F1> you will observe that unlike data entry (which displays as X’s or 9’s), text entry appears exactly as entered.

Changing or Deleting Text

Changing or deleting text is similar to modifying fields.

To delete a text, or change the location or wording of a text you have entered, get to the text screen by pressing <Enter> at the "Field #" field.

A window will display the Row, Column and Text of texts that have already been entered.:

Texts are shown in the order in which they were entered. Five texts are visible at a time; if the format contains more than this, you can page through them:

<PgUp>
<PgDn>

To view the previous or next page of texts

To delete a text, enter its row and column number and press <F3> when prompted to do so.

To change the wording of the text, enter its row and column number, select field 4 and enter new wording. You can also change the "Suppress ?" information by selecting field 5 and entering a new answer or new field number.

To change the row or column in which the text starts, select the text by its current row and column numbers, then change those from Field number to change ?.

When through specifying header fields and text to print, press <Esc> at Field #1.

Line Item and Payments Area

When entering a new invoice format, General appearance must be entered before this selection may be entered.

Add, change, and delete line item area fields and texts is handled in much the same way as header area fields and texts, except for minor differences

Row refers to a relative row, not the absolute row. That is, line item row 2 means the second row within each line item, not the second row on the invoice form.
The fields available in the body of the invoice are different from those in the header.
Where Job Cost is interfaced but Inventory Control is not, the following fields appear:

Job number

Sub-job number

Job description

Sub-job description

Where I/C is interfaced but J/C is not, the following field appears:

Item pricing unit

Where both I/C and J/C are interfaced, the following fields appear:

Job number

Job Cost category number

Job description

Category description

Sub-job number

Item pricing unit

Sub-job description

 

If Control information specifies no line item discounts, the fields which mention discounts do not appear, and Extended price appears instead.
Extended prices (with or without discount) are based on the quantity shipped.
Back order fields are only available when back ordering is allows in I/C. A/R invoices do not provide for back order control, but these same forms can be used to print an invoice from history which may have used back order control when posted from O/E.

Select

Line item area from the Invoice formats menu.

An entry screen will be displayed prompting you for the invoice format number that you want to work with.

Options 

Enter a format number, or use one of the options:

<F1>

For the next format on file

<SF1>

For the previous format on file

Format

99

Example

Type 11

The following screen displays for line item area:

Inserting Text in the Line Item Area

Entering text is the same as for headers, except for the Type field.

1. Field #

Options 

Enter the number of an invoice field from the display shown, leave this field blank to enter text, or use one of the options:

<PgUp>
<PgDn>

To move the display up or down one page.

<F1>

To view a schematic picture of the invoice.

Format

99

Example

Press <Enter>. The word Text will display.

The text screen appears as:

2. Row
3. Column

Enter the row and column where you want the text to begin.

Options 

If you have left Field #1 blank and if there are texts already on file for the line-item area, a window will display showing the existing texts. At each screen field from #2 through #5, you may use one of the options:

<PgUp>
<PgDn>

To view the previous or next page of texts

Format

99 for row

999 for column

Example

Type 1 for row

Type 1 for column

4. Type

Enter S if this text is to appear only for services line items, G if it is to appear only for goods line items, or B if it is to appear for both types.

There is no separate Type for Note line items. It is not possible to print text on a note.

Format

One letter from the list above. There is no default.

Example

Type B

5. Text

Enter the exact text which you want to appear for the type of line item specified above.

Format

40 characters

Example

Type Shipped per your instructions

6. Suppress ?

Answer Y if you want the text to be suppressed (not to print) when some field (to be specified next) is zero or blank. Answer N if you want the text to always print.

Format

One letter, either Y or N. the default is N.

Example

Press <Enter>

Field #

If you answered Y to Screen Field #6, the available line item fields display. Enter the number of the field which, when it contains zero or blank, will cause the text not to print.

Field number to change ?

Options 

Make any needed changes. Your options are:

<F1>

To view a schematic picture of the invoice

<F3>

(For an existing text only) To delete this text

Press <Enter> to complete this entry. The cursor moves to Screen Field #1.

Numeric Fields

The following example shows characteristics of numeric fields in addition to those shown by the example in the Header area.

Not all the screen fields described in this example appear for all invoice fields. It is explained in each case when a screen field is optional. The screen fields are always numbered sequentially from one. Depending on which invoice field you select, you may see a screen field numbered differently from that shown here.

Enter the information as follows:

1. Field #

Options 

Enter the number of an invoice field from the display shown, leave this field blank to enter text, or use one of the options:

<PgUp>
<PgDn>

To move the display up or down one page.

<F1>

To view a schematic picture of the invoice.

Format

99

Example

Press <PgDn>. Invoice field #19 will appear in the display.

Type 19 This will select the Item or service quantity invoice field.

The screen now appears as:

2. Row
3. Column

Enter the row and column where you want this numeric field to begin.

Format

99 for row

999 for column

Example

Type 2 for row

Type 2 for column

4. Number of integers

Enter the number of integers (digits to the left of the decimal point) you want to print in this field, up to the maximum shown.

Format

(As displayed for the selected field)

Example

Press <Enter> for the maximum of 8

5. Use commas ?

Answer Y to separate digits into groups of three by commas. This option is available only where appropriate (it would not be available for an invoice field such as the line number, which never gets large enough to require commas).

Format

One letter, either Y or N

Example

Type Y

5. Print lead zeros ?

Answer N to suppress leading zeros. This options is available only where appropriate. When printing line numbers, for example, this lets you choose between numbering the twelfth line as 12 or 012.

Format

One letter, either Y or N

Example

(Does not occur in this example)

6. Decimals

Enter the number of decimal places you want to print, up to the maximum shown. If the number has no decimals places, this choice does not appear.

Format

(As displayed for the selected field)

Example

Press <Enter> for the maximum of 5

7. Show negative with

Enter M to show negative numbers with a minus sign, or P to show them in parentheses.

For numeric fields which do not allow negative values, this selection either does not display, or displays N/A and does not allow you to make an entry.

If you select M, then enter L to have the minus sign on the left or R to have it on the right.
If you select P, then enter F to display the parentheses in fixed positions, or N to display the parentheses next to the number. For example, if the number were negative 35, typing F would result in “( 35)"; typing N would result in “(35)”.

Format

One letter at each field

Example

Type M, then L

8. Print when zero ?

Answer Y to print a zero when the number is zero, or answer N to leave the field blank when the number is zero.

This screen field only appears for appropriate invoice fields (amounts or quantities).

Format

One letter, either Y or N

Example

Type Y

Field number to change ?

An example appears to the right to show what your number will look like when printed. A negative number example is also shown if negative numbers are allowed.

Make any needed changes. Your options are:

<F1>

To view a schematic picture of the invoice

<F3>

(For an existing text only) To delete this text

Press <Enter> to complete this entry. The cursor moves to Screen Field #1.

Alphanumeric Fields

Alphanumeric fields are entered in line items the same way as they are in the header and total area. Be aware that each line of an item description, a service description, or a note is a separate field and must be formatted individually.

Suppose for instance that you wanted to save space by printing nine lines of a Note line-item on three lines of the invoice. You have a space on the form sixty characters wide to hold this information.

You would have to define three entries on the format for Service / Note description line #1 through #3 (Invoice Fields #8 through 10). These would occupy three adjacent 20-character fields on Row #1 of the line-item area.
You would do likewise for the remaining lines in Row #2 and Row #3.
You would specify in General appearance that the Maximum # of rows per line item was at least 3. This does not mean that every line item would occupy three lines, since trailing blank rows of a line item are not printed.
You would specify in Control information that the Service text length was 20. This will prevent an operator from inadvertently entering a line that would be truncated upon printing.
There is no way to limit the number of lines entered on an invoice, so if an operator inadvertently entered the tenth line of a Note line item (which is the maximum allowed), that line would not be printed on the invoice.

Payment Fields

Payment fields will only print if you are using Multi-payments per the A/R Control information. See the PBS Multi-payment Setup appendix.

Payment field rows must be entered below the line fields. Never put a payment field and a line item field on the same row. The first payment row must be larger number that the last line item row.

If you need three lines for printing the item and service information, one line in between the line items and payments and two lines for printing payments, then in the General appearance set the Maximum # of rows per line item to 6. The first row for the payment field, in this case, is five.

The payments float on the page depending on the number rows used for the last item line.

The payment fields start at 54 and go to 60 as seen in the field list below:

Totals Area

When entering a new invoice format, General appearance must be entered before this selection may be entered.

Adding, changing, or deleting totals area fields and texts is handled in much the same way as for the header area and the line-item area.

Variations in the available invoice fields include:

Where invoice discounts are not used, Invoice discount percent and Invoice discount amount do not appear, and Line item total less discount displays as Line item total.
Where Control information does not specify that cash is asked for with the invoice, Cash with invoice, Check #, Bank route number and Total invoice amt minus cash do not appear.

Select

Totals area from the Invoice formats menu.

An entry screen will be displayed prompting you for the invoice format number that you want to work with.

Options 

Enter a format number, or use one of the options:

<F1>

For the next format on file

<SF1>

For the previous format on file

Format

99

Example

Type 11

The following screen displays for the Totals area:

Printing with Floating Totals Selected

If you selected floating totals (in General appearance), enter a relative row number. For example, type 1 for the first row of the total area.

Otherwise, enter an absolute row number, counting from the top of the page.

Printing Floating Totals with a Laser Printer

When printing an invoice that uses "floating totals", the location of the multi-part label does not float. If you put the Laser multi-part label field at row 10 of the floating totals area, the label will print on the 10th row after the format’s Last row # for line item printing. On the last page of the invoice, this means that the multi-part label will not print on row 10 of the totals area, but on the 10th row after the format’s Last row # for line item printing. For example, in General appearance, if you enter 55 for last row # for item printing and you put the Laser multi-part label field at row 10 of the floating totals area, the label will print on row 65 of each page (55 + 10 = 65).

When printing an invoice, it is possible that a totals field may overlap the fixed location of the Laser multi-part label field. To avoid this, put the Laser multi-part label field on or near the last row of the floating totals area and locate it so that it does not print in the same columns as any other totals area fields. It is also possible to position the Laser multi-part label field so that its printed location (calculated as described above) falls beyond the number of rows on the form. To avoid this, make sure that the row # of the Laser multi-part label field plus the last row # for item printing does not exceed the number of rows on the form.

So that this invoice will print invoice totals and can be verified, enter the data on the following screen:

Verifying the Format

Invoice formats, indeed all A/R formats, must be verified before they can be used. This process diagnoses any errors which could not be detected when the format was entered. You can verify a format as soon as you have entered its General appearance.

Once an invoice has been verified it becomes available for use indefinitely, but as soon as you change it you have to verify it again. If you anticipate having to make extended changes to an invoice it is a good idea to copy it first under some other name, so that you can continue to use the old version while developing the new one.

There is no special screen for this selection; the program immediately begins checking the invoice format for errors.

At the end of the verification, an error report is printed. Some messages on the report are warnings and are identified by *WARNING ONLY *.

You can either correct warnings or leave them as they are.
Errors, however, must be corrected before you can use the format.

Select

Verify from Invoice formats menu.

An entry screen will be displayed prompting you for the invoice format number that you want to work with.

View a Verify Report example in the Sample Reports appendix.

Options 

Enter a format number, or use one of the options:

<F1>

For the next format on file

<SF1>

For the previous format on file

Format

99

Example

Type 11

Unless you have directed the error report to the screen, the following screen displays as the format is verified.:

Printing a Sample Invoice

This selection lets you print a sample invoice after you have verified it. The invoice you enter here must have been verified before you will be allowed to print this sample. If the invoice has not been verified, an informational message will be displayed and you will not be allowed to proceed.

Select

Sample Invoice from the Invoice formats menu.

An entry screen will be displayed prompting you for the invoice format number that you want to work with.

Options 

Enter a format number, or use one of the options:

<F1>

For the next format on file

<SF1>

For the previous format on file

Format

99

Example

Type 10

If you are answered Y to Use pre-printed forms ? in General appearance, a screen appears telling you to mount invoice forms on the printer. Mount these forms on the printer, then type DONE.

You may select a Company information printer or Windows printer. The following includes a description of each.

Company Information Laser Printer or PDF Printer

If you are printing the sample invoice on a laser printer, you will be asked to enter Up/down adjustment and Left/right adjustment amounts to adjust the alignment of the laser printer. The values last entered for these amounts are shown. After entering new values or accepting the values shown, the sample invoice is printed.

When using a -PDF- printer, as setup in Company information, the invoice is saved to a PDF file and displayed on screen in Adobe™ Reader™ or Adobe Acrobat™. Within the application you have other options with the invoice such as email, print and so on. The sample or alignment file is named ARI_ALIGNMENT_999999.PDF. Default configurations are provided for PDF files. See the PBS Administration documentation for information on the PDF configuration options and the setup of a Company information PDF printer.

You may view and email statements that have been generated to PDF files at Email/view printed PDFs under the CTL menu selection of PDF form file processing.

Windows Printer

If you selected Windows printer, the alignment starts for the upper left corner of the page. However, you should enter an amount greater than the default margin that displays at the bottom of the screen.

 

       Note 

Use the up/down and left/right adjustments for laser alignment to position the sample invoice information so that it exactly aligns with the pre-printed form. Pre-printed forms are produced according to very exact specifications, but the print position of laser printers may vary slightly from model to model or between manufacturers. These adjustment amounts allow you to compensate for the differences between laser printers so that your invoice information can be positioned correctly on the invoice form. (The early models of Hewlett-Packard laser printers, such as the LaserJet+ and more recent ‘Windows only’ printers do not support this adjustment feature. These printers do not respond to certain codes provided by PBS for making alignment adjustments.)

Press <F1> at any time to stop printing.

After one sample invoice prints, you are asked whether or not you want to print another sample invoice.

Print sample invoice again ?

Answer Y to print the sample invoice again or N to exit this function.

If you select Y you will be positioned to print another invoice form.

If you select N and you are using pre-printed forms, you will be prompted to replace these forms with plain paper. Type DONE to the question Please mount regular paper on printer.

Printing Format Specifications

Use this option to print a full list of the exact specifications that define one or more invoice formats. This is different from a sample invoice-a sample invoice shows what the invoice will look like. The format specifications show the location and other properties of all fields entered.

Select

Format specifications from the Invoice formats menu.

The following screen appears:

Enter the information as follows:

Starting format #
Ending format #

Enter the range of the formats you want to print. You may use the option:

<F2>

For the First starting format or Last ending format

Format

99 at each field

Example

Press <F2> at each field

Any change ?

Answer Y to re-enter this screen, or N to print the Format Specifications.

Copying Invoice Formats

If you have already created an invoice format which you want to keep, and you are going to add another similar format, use this option to copy the existing format. Then make changes to the copy.

Select

Copy from Invoice formats menu.

The following screen appears:

Enter the information as follows:

1. Copy from format #

Options 

Enter the number of the format you want to copy from. This must be an existing format, but need not have been verified. Copied formats have the same verification status as the formats they were copied from. You may use the options:

<F1>

For the next format on file

<SF1>

For the previous format

Upon entry or selection of a valid format, its name and verification status are displayed.

Format

99

Example

Type 11

2. Copy to format #

Enter the number you wish to assign to the new format. This may not be an existing format.

Format

99

Example

Type 99

3. Description

Enter a description for the new format.

Format

25 characters

Example

Type Copy of format 11

Field number to change ?

Make any needed changes, then press <Enter>. There will be a period of processing as the format is copied. You will be notified when this has completed; press <Esc> to return to the menu.

       Note 

MULTI-COMPANY NOTE: If you use the Passport Business Solutions multi-company feature, you can copy the file containing invoice formats from one company to another using the operating system facilities for copying files. Invoice formats are stored in the IVCFMT00 where "00" is the Company ID. For example, if you have invoice formats for company 00, they reside in the file IVCFMT00.DAT and IVCFMT00.vix. Copy these files to the appropriate folder (directory) replacing "00" within the filename with a new Company ID.

Then use the Invoice formats function from within the new company to modify or delete any of the invoice formats for the new company.

Deleting Invoice Formats

Use this option to delete invoice formats which you no longer want.

Select

Delete from the Invoice formats menu.

The following screen appears:

Enter the information as follows:

Please enter number of format to delete

Options 

Enter the number of the format you want to delete. This must be an existing format, but need not have been verified. You may use the options:

<F1>

For the next format on file

<SF1>

For the previous format

Upon entry or selection of a valid format, its name and verification status are displayed.

Format

99

Example

Type 11

Any change ?

Answer Y to re-enter this screen, or N to delete the format.

Format

One letter, either Y or N. The default is N.

Example

Press <Enter>

There will be a period of processing as the format is deleted. You will be notified when this has completed; press <Esc> to return to this screen for the next format to be deleted.